﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Pokusaj1
{
    public class NapuniDdl
    {
     
        public System.Data.DataSet Klijenti()
        {
            var dsklijenti = new System.Data.DataSet();
            string upit = @"SELECT 'SVE' AS Naziv UNION ALL SELECT DISTINCT Naziv FROM Klijent";
            var ds = new ProxyBaze();
            dsklijenti = ds.NapuniDataset(upit);
            return dsklijenti;           

        }
        public System.Data.DataSet Mesto()
        {
            var dsmesto = new System.Data.DataSet();
            string upit = @"SELECT 'SVE' AS Mesto UNION ALL SELECT DISTINCT Mesto FROM Klijent";
            var ds = new ProxyBaze();
            dsmesto = ds.NapuniDataset(upit);
            return dsmesto;

        }

        public System.Data.DataSet Robe()
        {
            var dsrobe = new System.Data.DataSet();
            string upit = @"SELECT 'SVE' AS NazivRobe UNION ALL SELECT DISTINCT NazivRobe FROM Roba";
            var ds = new ProxyBaze();
            dsrobe = ds.NapuniDataset(upit);
            return dsrobe;

        }


    }
}